from tools.excile import Excile
from tools.sql import Sql
import yaml
class data_dxm:
    @staticmethod
    def excile_da(sheet,r_min,c_max):
        c = Excile('examp.xlsx')
        data=c.read('examp.xlsx',sheet,r_min,c_max)
        return data
    @staticmethod
    def sql_da():
        s=Sql('finance','user')
        data=s.select()
        return data

    @staticmethod
    def list_da():
        list1=[['lisi','123456','个人理财系统'],['lisi','123456','个人理财系统']]
        return list1

    @staticmethod
    def read_yaml(path):
        with open(path, "r",encoding='utf-8') as f:
            return yaml.safe_load(f)
# data=data_dxm.read_yaml('ym.yaml')
# print(data)

